Excel 2007 Dashboards & Reports For Dummies by Michael Alexander

Author:Michael Alexander
Language: eng
Format: epub, pdf
Publisher: Wiley

By default, the picture that’s created has a border around it. To remove the border, simply right-click the picture and select Format Picture. This activates the Format Picture dialog box. In the Colors and Lines tab, you see a Line Color drop-down list. Here you can select No Color, thereby removing the border.

On a similar note, to get a picture without gridlines, simply remove the gridlines from the source range.

Creating a live picture without the Camera tool

Did you know you can create a live picture without actually using the Camera tool? That’s right. Excel 2007 has made it relatively easy to mimic the Camera tool functionality manually.

1. Select the target range and copy it.

2. Go to the Home tab on the Ribbon and choose Paste⇒As Picture⇒Paste Picture Link.

Of course, the advantage of using the Camera tool is that you can do the same thing with two clicks. Call me lazy, but two-click functionality is just too good to pass up.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.